<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>FileHelpers Library - Marcos Meli</TITLE>
<LINK href="/favicon.ico" rel="SHORTCUT ICON"><LINK 
href="global.css" type=text/css 
rel=stylesheet>
<meta NAME="Description"        content="An easy to use .NET library to read/write data from fixed length or delimited files or streams. It has support to import/export data from different data sources." />
<meta name="Author"             content="Marcos Meli" />
<meta NAME="keywords" Content="filehelpers,CSV,Marcos_Meli,C#,free,opensource,Devoo.net,Delimited Files,Import/Export">
<meta NAME="Copyright" CONTENT="Copyright 2005-07 to Marcos Meli - www.Devoo.net. All Rights Reserved.">

<style type="text/css">
<!--
.style1 {color: #000000}
.style6 {font-size: 11pt; font-weight: bold; }
.style8 {color: #000066}
.style9 {font-family: "Courier New", Courier, mono}
.style14 {color: 0}
-->
</style>
</HEAD>
<SCRIPT language=JavaScript>

var Selected = "";
var AdTime = new Date();

function SwitchMessage(elm)
{
	
	var elmref;
	if (Selected != "")
	{
		elmref = eval("document.getElementById('" + Selected + "_h1')");
		if (elmref) elmref.style.display = 'none';
		elmref = eval("document.getElementById('" + Selected + "_h0')");
		if (elmref) elmref.bgColor = '#FEF9E7';
	}
	if (Selected != elm.name) 
	{
		Selected = elm.name;
		elmref = eval("document.getElementById('" + Selected + "_h1')");
		if (elmref) 
		{
			if (elmref.style.display=='none') elmref.style.display='';
			else elmref.style.display = 'none';
		}
		elmref = eval("document.getElementById('" + Selected + "_h0')");
		if (elmref) 
			elmref.bgColor = '#99CCFF';
	}
	else
		Selected="";
		
	return false;
}


</SCRIPT>

<SCRIPT language=javascript event=onclick for=DynMessLink>
return SwitchMessage(this);
</SCRIPT>

<BODY   text=black vLink=purple aLink=red link=blue 
bgColor=white leftMargin=0 topMargin=0>

     		{$HEADER$}


<table cellpadding="5" cellspacing="5">
<tr><td><div id=contentdiv>
        <h2>Frequent Asked Questions </h2>
        <blockquote>
          <p>Here you find the most common problems that you can find using this lib.</p>
          <table width="96%"  border="0" cellpadding="6" cellspacing="4">
            <tr valign="top" id=DynMessLink name=11>
              <td width="7" height="39"><span class="style1"><span class="style6"><img src="dot.gif" width="9" height="9"></span></span></td>
              <td width="630" bordercolor="#00CCCC" bgcolor="#FEF9E7" class="FeatureBox"><span class="style14"> <a href="">Vs.net say: &quot;The type or namespace name 'FileHelperEngine' could not be found&quot;</a></span></td>
            </tr>
            <tr valign="top" id=11_h1 style="DISPLAY: none">
              <td width="7" height="114">&nbsp;</td>
              <td><p class="style1">You must add a reference to the FileHelpers.dll:</p>
                <blockquote>
                  <p class="style1"><img src="references.png" width="103" height="53"></p>
                </blockquote>                <hr align="left" width="100%" /></td>
            </tr>
            <tr valign="top" id=DynMessLink name=12>
              <td width="7"><span class="style1"><span class="style6"><img src="dot.gif" width="9" height="9"></span></span></td>
              <td bgcolor="#FEF9E7" class="FeatureBox"> <a href="">Vs.net say: &quot;The type or namespace name 'DelimitedRecord' could not be found (are you missing a using directive or an assembly reference?)&quot;</a></td>
            </tr>
            <tr valign="top" id=12_h1 style="DISPLAY: none">
              <td width="7" height="142" >&nbsp;</td>
              <td>              You must add an <span class="style9">using</span> or <span class="style9">imports</span> directive:
                <blockquote>
                  <pre class="style1"><span class="style8">C#:</span>     <span class="cs-keyword">using</span> FileHelpers 

<span class="style8">VB.NET</span>: <span class="cs-keyword">Imports</span> FileHelpers </pre>
                </blockquote>
                                <hr align="left" width="100%" />              
              </td>
            </tr>
            <tr valign="top" id=DynMessLink name=13>
              <td width="7"><span class="style1"><span class="style6"><img src="dot.gif" width="9" height="9"></span></span></td>
              <td bgcolor="#FEF9E7" class="FeatureBox"><span class="style1"> <a href="">I got a BadUsageException when instanciate a FileHelperEngine class</a></span></td>
            </tr>
            <tr valign="top" id=13_h1 style="DISPLAY: none">
              <td width="7" height="36" >&nbsp;</td>
              <td><p class="style1"> The exception message say you what attribute or condition is wrong.</p>
                <hr align="left" width="100%" /></td>
            </tr>
            <tr valign="top" id=DynMessLink name=14>
              <td width="7"><span class="style1"><span class="style6"><img src="dot.gif" width="9" height="9"></span></span></td>
              <td bgcolor="#FEF9E7" class="FeatureBox"><a href="">How can indicate that a file is quoted with &quot;...&quot; or other char ? </a></td>
            </tr>
            <tr valign="top" id=14_h1 style="DISPLAY: none">
              <td width="7">&nbsp;</td>
              <td>You must use the <a href="FileHelpers.FieldQuotedAttribute.html">FieldQuotedAttribute</a> like this:
                <blockquote>
                  <pre>[FieldQuoted]<span class="cs-keyword">
public string </span>CustomerName</pre>
              </blockquote>                <hr align="left" width="100%" />                </td>
            </tr>
            <tr valign="top" id=DynMessLink name=15>
              <td><span class="style1"><span class="style6"><img src="dot.gif" width="9" height="9"></span></span></td>
              <td bgcolor="#FEF9E7" class="FeatureBox"><a href="">I have a file with fixed format what attributes must use ? </a></td>
            </tr>
            <tr valign="top" id=15_h1 style="DISPLAY: none">
              <td width="7" height="236">&nbsp;</td>
              <td><p>You must use the <a href="FileHelpers.FixedLengthRecordAttribute.html">FixedLengthRecordAttribute</a> for the class and the <a href="FileHelpers.FieldFixedLengthAttribute.html">FieldFixedLengthAttribute</a> for the fields: </p>
                <blockquote>
                  <pre>[FixedLengthRecord] 
<span class="cpp-keyword">public class</span> OrdersFixed
{ 
    [FieldFixedLength(7)] <br>    <span class="cs-keyword">public int</span> OrderID;

    [FieldFixedLength(12)]
    <span class="cs-keyword">public string</span> CustomerID;

    ....</pre>
                </blockquote>                <hr align="left" width="100%" /></td>
            </tr>
            <tr valign="top" id=DynMessLink name=16>
              <td width="7"><span class="style1"><span class="style6"><img src="dot.gif" width="9" height="9"></span></span></td>
              <td bgcolor="#FEF9E7" class="FeatureBox"><a href="">I have a file with a delimiter  what attributes must use ? </a></td>
            </tr>
            <tr valign="top" id=16_h1 style="DISPLAY: none">
              <td>&nbsp;</td>
              <td><p>You must use the <a href="FileHelpers.DelimitedRecordAttribute.html">DelimitedRecordAttribute</a> for the class and the <a href="FileHelpers.FieldDelimiterAttribute.html">FieldDelimiterAttribute</a> for the fields: </p>
                <blockquote>
                  <pre>[DelimitedRecord(<span class="cs-string">&quot;|&quot;</span>)] 
<span class="cpp-keyword">public class</span> OrdersFixed
{ 
    <span class="cs-keyword">public int</span> OrderID;
   <span class="cs-keyword"> public string</span> CustomerLastName;
    <span class="cs-keyword">public int</span> CustomerFisrt;
   ...</pre>
                </blockquote>                <hr align="left" width="100%" />                </td>
            </tr>
            <tr valign="top" id=DynMessLink name=17>
              <td><span class="style1"><span class="style6"><img src="dot.gif" width="9" height="9"></span></span></td>
              <td bgcolor="#FEF9E7" class="FeatureBox"><a href="">How i can set the field date format ? </a></td>
            </tr>
            <tr valign="top" id=17_h1 style="DISPLAY: none">
              <td>&nbsp;</td>
              <td>You must use the<a href="FileHelpers.FieldConverterAttribute.html"> ConverterAttribute</a>
with the format:              
  <blockquote>
                  <pre>[FieldConverter(<a href="FileHelpers.ConverterKind.html">ConverterKind</a>.Date, <span class="cs-string">"ddMMyyyy"</span> )]
<span class="cs-keyword">public DateTime</span> ShippedDate;

[FieldConverter(<a href="FileHelpers.ConverterKind.html">ConverterKind</a>.Date, <span class="cs-string">"MMddyyyy"</span> )]
<span class="cs-keyword">public DateTime</span> ShippedDate;

[FieldConverter(<a href="FileHelpers.ConverterKind.html">ConverterKind</a>.Date, <span class="cs-string">"d/M/yyyy"</span> )]
<span class="cs-keyword">public DateTime</span> ShippedDate;

[FieldConverter(<a href="FileHelpers.ConverterKind.html">ConverterKind</a>.Date, <span class="cs-string">"d-M-yy"</span> )]
<span class="cs-keyword">public DateTime</span> ShippedDate;</pre>
              </blockquote>  <hr align="left" width="100%" />  </td>
            </tr>
            <tr valign="top" id=DynMessLink name=18>
              <td><span class="style1"><span class="style6"><img src="dot.gif" width="9" height="9"></span></span></td>
              <td bgcolor="#FEF9E7" class="FeatureBox"><a href="">My files has a header line, how i can ignore it ? </a></td>
            </tr>
            <tr valign="top" id=18_h1 style="DISPLAY: none">
              <td>&nbsp;</td>
              <td bordercolor="#000000">You can use the <a href="FileHelpers.IgnoreFirstAttribute.html">IgnoreFirstAttribute</a>.
                <blockquote>
                  <pre>[IgnoreFirst] <span class="cs-comment">// Discard one line
</span><span class="cs-keyword">public class</span> OrdersVerticalBar 
{ ...</pre>
                  <pre>[IgnoreFirst(2)] <span class="cs-comment">// Discard two lines</span>
<span class="cs-keyword">public class</span> OrdersVerticalBar 
{ ...</pre>
              </blockquote>                <hr align="left" width="100%" /></td>



            <tr valign="top" id=DynMessLink name=20>
              <td><span class="style1"><span class="style6"><img src="dot.gif" width="9" height="9"></span></span></td>
              <td bgcolor="#FEF9E7" class="FeatureBox"><a href="">When I use the ExcelStorage I get a type not defined error... </a></td>
            </tr>
            <tr valign="top" id=20_h1 style="DISPLAY: none">
              <td>&nbsp;</td>
              <td bordercolor="#000000">You need to add a reference to the FileHelpers.ExcelStorage.dll because the ExcelStorage class is defined in this assembly.<br>
              <b>Remember</b> you don't must to reference to the Interop files directly.
<hr align="left" width="100%" /></td>
            </tr>





            </tr>
            <tr valign="top" id=DynMessLink name=99>
              <td><span class="style1"><span class="style6"><img src="dot.gif" width="9" height="9"></span></span></td>
              <td bgcolor="#FEF9E7" class="FeatureBox"><a href="">I need that the library include a new feature or documentation ? </a></td>
            </tr>
            <tr valign="top" id=99_h1 style="DISPLAY: none">
              <td>&nbsp;</td>
              <td bordercolor="#000000">Go to the <a href="credits.html">Contact Page</a> and send me a mail with your ideas, if the feature is easy or useful i add it to the FileHelpers.
<hr align="left" width="100%" /></td>
            </tr>

          </table>
        <p><b>More questions ??</b> search it below or send your question to the list.</p>
        <center>
             <FORM method=GET action=http://www.google.com/custom>
                    <table border="0" cellpadding="2" cellspacing="0" >
                        <tr>
                            <td valign="top" style="height: 116px">
                                <img src="logo_search.png" border="0"><br /><INPUT TYPE=text name=q maxlength=200 value="" style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-LEFT: black 1px solid; COLOR: navy; BORDER-BOTTOM: black 1px solid; FONT-FAMILY: Verdana; BACKGROUND-COLOR: #f8fcff; width: 171px;"><INPUT type=submit name=sa VALUE="Search" style="BORDER-RIGHT: royalblue 1px solid; BORDER-TOP: royalblue 1px solid; FONT-WEIGHT: bold; BORDER-LEFT: royalblue 1px solid; CURSOR: hand; COLOR: white; BORDER-BOTTOM: royalblue 1px solid; FONT-FAMILY: Verdana; HEIGHT: 21px; BACKGROUND-COLOR: navy"><INPUT type=hidden name=cof VALUE="S:http://www.filehelpers.com;AH:center;LH:64;L:http://www.filehelpers.com/logo_search.png;LW:244;AWFID:82b822b221689c96;"><input type=hidden name=domains value="www.filehelpers.com"><input type=hidden name=sitesearch value="www.filehelpers.com" checked></td>
                            <td style="width: 20px; height: 116px">
                            </td>
                            <td align="center" valign="top" style="height: 116px">
                                <img src="logo_mailing.png" border="0"><br />
                                <a href="mailto:filehelpers-general-request@lists.sourceforge.net?subject=subscribe">
                                    <img src="list_subscribe.png" border="0" style="margin-right: 7px"></a><a href="http://www.mail-archive.com/filehelpers-general%40lists.sourceforge.net/"><img src="list_browse.png" border="0" style="margin-left: 7px"></a></td>
                        </tr>
                    </table>
		</FORM>
    </center>
        </blockquote>
		{$FOOTER$}
</tr>
</table>

</BODY></HTML>
